pp108 : Creating an MDM Model

Creating an MDM Model

This topic describes the procedure to create an MDM model.

The MDM model acts as the framework for intergrating data of the organization. The primary step in designing an MDM model is to identify the data stores that will act as spokes and hub in the model. Any change related to the data in the spoke is communicated to the hub. If required, the hub may propagate the change to the remaining spokes in the model.
An MDM model can be designed in the following ways:

  • Empty model: The architecture of this model can be built manually by inserting the data stores.
  • Simple Synchronization Model: This kind of model can be built automatically by specifying the number of spoke data stores that are to be connected to the hub.
  1. Create a Workspace and click (MDM Model). A Choose a template before you begin dialog box will appear.
  2. You can do one of the following:
    1. To create an Empty Model, select Empty Model from the dialog box and click OK and do the following in the <Untitled MDM Model> window that appears.
      1. Drag the hub and all the required spoke data stores from the Workspace explorer window to the modeling area. The Select entities for MDM <Hub or Spoke> Data Store window appears.

        Tip: To accelerate the modeling process and quickly draw constructs, see Easy Ways to Draw Constructs in Design Time in Design Time topic.

        • To quickly add a data store to draw an MDM model, click the Insert tab and drag the desired document to the MDM modeler canvas. Alternatively, click the Workspace tab in the modeler and drag the required document to the MDM modeler. To create a new data store you can directly drag Hub Data store or Spoke Data store from the Toolbox to the canvas and drag the data entities on to the Data stores.
        • To quickly associate a data entity or a subscription with another document, such as a Schema Fragment, MDM State Model, MDM Sequence Generator, Data Quality Plan, MDM Subscription Handler, Data Transformation, or a Rule, click the Insert tab and select the desired document. Alternatively, click the Workspace Explorer tab in the modeler and drag the required document onto a construct in the MDM Model.
      2. Select the required data entities from the list and click Add button. The data store appears on the modeling area.
      3. Select the hub or spoke entity on the modeling area, click (Add connector) from the tool bar and click the hub or spoke entity to draw subscriptions between the hub and spoke entities. Alternatively, click source entity, press CTRL key on the keyboard and click the destination entity to draw subscriptions.
    2. To create Simple Synchronization Model, select (Simple Synchronization Model) and do the following:
      1. Enter the number of spoke data stores that need to be subscribed to the hub data store in the Number of Spoke Data Store field.
      2. Click OK. An MDM model is created with the specified number of spokes connected to the hub.
  3. To define the properties of the model, perform the following steps:
    1. Double-click or right-click the Spoke or Hub data store and select properties. The Property pane is displayed.
    2. Enter the Data Store Properties such as the name, description of the data store.
    3. Enter the Data Entities Properties for each data entity in the Property pane.
  4. Double-click each subscription link in the model. The subscription properties pane is displayed.
  5. Enter the subscription properties for each link. For more information on the fields in the subcription properties interface, refer to Subscription Properties Interface.
  6. Click .
    The MDM model is created and ready for data integration.

After you complete this task

  • Validate the MDM model.
    Note: Whenever you update a record in a database table, MDM sends the updated record with all the columns instead of sending only the columns that were updated. If you are updating different columns of a particular record from two or more sources, the previous content will be overwritten by the latest content thus leading to data loss and data inconsistency as the entire record is updated. Therefore, to ensure that only the updated/modified columns are propagated during sniffing, before publishing the model, select the Allow Modified Fields Only option in the MDM Admin settings page.
  • Publish the MDM model to organization before you start data integration.